All Questions
Tagged with postgresqlusers
8 questions
1vote
0answers
227views
psql asks for a password when username in host and postgres server are identical?
I have a postgres server running in a docker container. I added a user there named "myuser". I also have a linux user named "myuser". Then (as root) I do: $ su - myser $ psql ...
- 351
0votes
2answers
866views
Slackware and postgres
I want to install postgres and psql via a Slackbuild and I did so. After installing it I tried running the command as suggested in the readme of the Slackbuild but I get an error upon running it as ...
- 11
2votes
2answers
7kviews
root "su - <user>" got permission denied (Ignored)
Got permission denied when switching user from root to postgres. No issue switching from root to ubuntu. root@node-01:~# su - postgres su: Permission denied (Ignored) postgres@node-01:~$ logout root@...
- 171
1vote
2answers
15kviews
Why can't I `su postgres`?
I wonder why when I provide root's password, the following command reports failure? $ su postgres Password: su: Authentication failure Is it correct that su asks for the password of root, not of ...
- 106k
0votes
1answer
1kviews
Fail to change user from postgres to other
When I try to change user (starting as postgres user) using the command sudo -i -u ubuntu The password for postgres is prompted. Now the postgres account was created upon installing postgres, and I ...
- 103
103votes
4answers
281kviews
Command to list PostgreSQL user accounts?
There are createuser & dropuser commands: createuser - define a new PostgreSQL user account dropuser - remove a PostgreSQL user account Is there a corresponding way to list the user accounts? ...
- 3,714
6votes
3answers
2kviews
Passwords for newly created users?
I am fairly new to Linux and I have question regarding users. When I use the useradd command I don't specify a password. I must use the passwd command afterwards. Does this mean that the user is ...
- 161
0votes
1answer
169views
How to restore the user postgres?
In the second answer in this thread is a warning about changing the UNIX password for "postgres". I have already changed the password for "postgres". How could I restore the initially state of the ...
- 1,631
